YRMO Dates dimension

The YRMO Dates dimension is a simpler version of the Cal Dates dimension table, which helps processing and performance speed of the system.

TIP: You can manage your dimension tables by downloading them in spreadsheet form so that you can make larger changes more easily. You can then upload the spreadsheet with the changes back into the system. For more information, see Editing a dimension using a spreadsheet.

Accessing the YRMO Dates dimension

From the Enterprise Decision Support home page, in the Data Control section, click Data Management > Core Dimensions > YRMO Dates.

Click image to view full size

The page can only display up to a maximum of 10,000 records.

NOTE: At this time, you can only add records in this dimension table directly through Axiom Explorer > Table Library > !Dimensions > CALDATE in the Windows or Excel Client. For more information, see Opening dimension tables in spreadsheet mode.

Filtering records

To filter records:

  1. Click the funnel icon in the upper left corner of the page.

  2. In the Filter box, you can narrow down the records to display by selecting or creating a filter using the Filter Wizard. To access the Filter Wizard, click Edit. If you are familiar with writing filter statements, you can type the statement syntax directly in the Filter box.
  3. Click Apply.

Column descriptions

This section provides descriptions for each column in the YRMO Dates dimension table:

NOTE: The table may display some columns that are related to other Syntellis products or have been created specifically for your organization. Contact your Syntellis Implementation Consultant or Syntellis Support if you need help with these columns.

Keys

Every table in the database must have at least one key column. Key columns define unique records of data in the table. If a table has one key column, then each value in that key column must be unique and defines a unique record in the table. If a table has multiple key columns, then each combination of values in those key columns defines a unique record in the table.

YRMO - Zero (0) is a default value, 999999 is used in costing to denote a current effective date range (To /From).

Cost

These columns are specific to the set up and maintenance of Axiom Enterprise Decision Support.

CQtr - The calendar quarter.

CQtrCount - The month counter within a quarter period.

FYear - The fiscal year.

FMonth - The fiscal month. It is the same as the GL Period associated with YRMO to link patient centric tables with the CGL tables.

FQtr - The fiscal quarter.

FQtrCount - The month counter within a quarter period.

DaysInMth - The number of days in a month.

CopyPass - Reserved for future use.

MonthName - The name of the month.

LongName - Month, yyyy

ShortName - mmm-yyyy

FLongName - Month, Fiscal yyyy

FShortName - mmm-Fiscal yyyy